GrapeCity.CalcEngine.Functions Namespace > CalcSumIfsFunction Class > Evaluate Method : Evaluate(Object[]) Method |
The args contains 3 - 255 items: sum_range, criteria_range1, criteria1, [criteria_range2], [criteria2], ..
Sum_range is one or more cells to sum, including numbers or names, arrays, or references that contain numbers.
Criteria_range1, criteria_range2, ... are 1 to 126 ranges in which to evaluate the associated criteria.
Criteria1, criteria2, ... are 1 to 126 criteria in the form of a number, expression, cell reference, or text that define which cells will be added.
'Usage Dim instance As CalcSumIfsFunction Dim args() As Object Dim value As Object value = instance.Evaluate(args)
The args contains 3 - 255 items: sum_range, criteria_range1, criteria1, [criteria_range2], [criteria2], ..
Sum_range is one or more cells to sum, including numbers or names, arrays, or references that contain numbers.
Criteria_range1, criteria_range2, ... are 1 to 126 ranges in which to evaluate the associated criteria.
Criteria1, criteria2, ... are 1 to 126 criteria in the form of a number, expression, cell reference, or text that define which cells will be added.
Target Platforms: Windows Server 2012, Windows RT